Statistics for Maintenance Modelling: Continuous Lifetime Distributions 1

# Hint¤

Assuming cell that is in cell A1 the probability density function is:

f(t) = EXP( (t - ) / A1) * EXP( -EXP( (t - ) / A1)) / A1

Using the Solver facility (accessed from the Tools menu), if you've typed the expression for f(t) in B1 then:

- the Target Cell for solver should be B1
- select the Max radio button for Equal To
- the By Changing Cells entry should be A1
- there should be a Constraint of A1 >= 0.0001 (to avoid dividing by zero)

Then click the Solve button.

Close